﻿
CREATE VIEW [dbo].[sankit_PersonalMedical]
AS
SELECT     dbo.Persoane.NumePrenume, dbo.Persoane.IdPersoana
FROM         dbo.Persoane INNER JOIN
                      dbo.AngajatiSalarizare ON dbo.Persoane.IdPersoana = dbo.AngajatiSalarizare.IdPersoana
WHERE     (dbo.AngajatiSalarizare.ServiciiPeChitanta = 1)